﻿CREATE TABLE [common].[HistoricalPrice] (
    [Id]         BIGINT          IDENTITY (1, 1) NOT NULL,
    [CompanyId]  BIGINT          NOT NULL,
    [PriceDate]  DATE            NOT NULL,
    [OpenPrice]  DECIMAL (19, 6) NULL,
    [HighPrice]  DECIMAL (19, 6) NULL,
    [LowPrice]   DECIMAL (19, 6) NULL,
    [ClosePrice] DECIMAL (19, 6) NULL,
    [Volume]     BIGINT          NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

